package com.manage.dao;

import com.manage.pojo.Housing;

import java.sql.SQLException;
import java.util.List;

public interface HousingDao {
    //连表查询所有
    public List<Housing> findAll() throws SQLException;
//    连表分页查询
    public List<Housing> findAll(int page, int limit) throws SQLException;
// 删除小区
    public int deleteHousingByHid(int hid) throws SQLException;
    //添加小区
    int insertHousing(Housing housing) throws SQLException;
//查询一个
    Housing selectOne(int hid)throws SQLException;
//修改
    int updateEmp(Housing housing)throws SQLException;
//搜索查询
    List<Housing> selectBySearch(int page, int limit, String hname, String hhiredate)throws SQLException;
    //搜索查询总条数
    int selectBySearchCount(String hname, String hhiredate)throws SQLException;

}
